﻿CREATE TABLE [dbo].[EmergencyMessageContent] (
    [ContentDescription]          VARCHAR (500) NULL,
    [IncidentCode]                VARCHAR (500) NULL,
    [IncidentDescription]         VARCHAR (500) NULL,
    [Confidentiality]             VARCHAR (100) NULL,
    [Type]                        NCHAR (10)    NOT NULL,
    [Id]                          INT           IDENTITY (1, 1) NOT NULL,
    [EmergencyMessageContainerId] INT           NOT NULL,
    [DSCHash]      INT           NOT NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Emergency message elements extracted from an Emergency Data Exchange Language (EDXL) XML document.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Human readable text describing the message content', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'ContentDescription';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The human readable text that uniquely identifies the incident/event/situation.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'IncidentCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The human readable text describing the incident/event/situation.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'IncidentDescription';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Special requirements regarding confidentiality of the message content.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'Confidentiality';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Unique identifier generated by the database management system', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'Id';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Reference to the associated emergency message container.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'EmergencyMessageContainerId';

GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Hash code of Distribution Id, Sender Id, and Content Description .', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'EmergencyMessageContent', @level2type = N'COLUMN', @level2name = N'DSCHash';

